<?php


class CREATEReportDevicesTable extends \PhpClickHouseLaravel\Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        // static::write('
        //     CREATE TABLE report_devices (
        //         `id` Nullable(UInt32),
        //         `reqType` Nullable(UInt32),
        //         `reqLength` Nullable(UInt32),
        //         `reqId` Nullable(UInt32),
        //         `reqDate` Nullable(DateTime),
        //         `startChar` Nullable(String),
        //         `commandIdentification` Nullable(UInt32),
        //         `responseMark` Nullable(UInt32),
        //         `Vin` String,
        //         `encryptionManner` Nullable(UInt32),
        //         `dataUnitLength` Nullable(UInt32),
        //         `checkCode` Nullable(UInt32),
        //         `loginSerialNumber` Nullable(UInt32),
        //         `iccid` Nullable(String),
        //         `chargeableEnergyStorageSubsystemQuantity` Nullable(UInt32),
        //         `chargeableEnergyStorageSystemLength` Nullable(UInt32),
        //         `chargeableEnergyStorageSystemCode` Nullable(UInt32),
        //         `year` Nullable(UInt32),
        //         `month` Nullable(UInt32),
        //         `day` Nullable(UInt32),
        //         `hour` Nullable(UInt32),
        //         `minute` Nullable(UInt32),
        //         `second` Nullable(UInt32),
        //         `infoTypeMarks` Nullable(String),
        //         `vehicleState` Nullable(Float32),
        //         `chargingState` Nullable(Float32),
        //         `operationMode` Nullable(Float32),
        //         `vehicleSpeed` Nullable(Float32),
        //         `accumulatedMileage` Nullable(Float32),
        //         `totalVoltage` Nullable(Float32),
        //         `totalCurrent` Nullable(Float32),
        //         `soc` Nullable(Float32),
        //         `dcState` Nullable(Float32),
        //         `gearPosition` Nullable(Float32),
        //         `insulationResistance` Nullable(Float32),
        //         `acceleratorPedalStroke` Nullable(Float32),
        //         `brakePedalState` Nullable(Float32),
        //         `quantityOfElectricalMach` Nullable(Float32),
        //         `listOfElekMachAssemblyInfo` Nullable(String),
        //         `engineState` Nullable(Float32),
        //         `crankshaftSpeed` Nullable(Float32),
        //         `fuelConsumption` Nullable(Float32),
        //         `positioningState` Nullable(Float32),
        //         `longitude` Nullable(String),
        //         `latitude` Nullable(String),
        //         `maxVoltageBSSId` Nullable(Float32),
        //         `maxVoltageCellId` Nullable(Float32),
        //         `maxCellVoltage` Nullable(Float32),
        //         `minVoltageBSSId` Nullable(Float32),
        //         `minVoltageCellId` Nullable(Float32),
        //         `minCellVoltage` Nullable(Float32),
        //         `maxTemperatureSSId` Nullable(Float32),
        //         `maxTemperatureSPCode` Nullable(Float32),
        //         `maxTemperatureValue` Nullable(Float32),
        //         `minTemperatureSSId` Nullable(Float32),
        //         `minTemperaturePSSCode` Nullable(Float32),
        //         `minTemperatureValue` Nullable(Float32),
        //         `highestWarningLevel` Nullable(Float32),
        //         `generalWarningData` Nullable(Float32),
        //         `chargeableESDFaultNumber` Nullable(Float32),
        //         `electricalMachineFaultsTotalNumber` Nullable(Float32),
        //         `engineFaultsTotalNumber` Nullable(Float32),
        //         `otherFaultsTotalNumber` Nullable(Float32),
        //         `chargeableESSSQuantity` Nullable(Float32),
        //         `voltageInfoChargeableESSSList` Nullable(String),
        //         `quantityOfCrgEnergyStgSubsystem` Nullable(Float32),
        //         `listOfSubsystemTempInfo` Nullable(String),
        //         `logoutSerialNumber` Nullable(Float32),
        //         `AcTime` DateTime)
        //     ENGINE = MergeTree PARTITION BY toYYYYMM(AcTime)
        //     ORDER BY(Vin, AcTime)  SETTINGS index_granularity = 8192
        // ');
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        // static::write('DROP TABLE report_devices');
    }
}
